What are the different modes of firing triggers?
2803
15-Jun-2013
Updated on 23-Sep-2020
Sumit Kesarwani
15-Jun-2013After Trigger: An AFTER trigger fires after SQL Server completes all actions successfully.
Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire.